USE [LocalDB]
GO
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name = 'Gene') BEGIN
	EXEC ('CREATE SCHEMA [Gene]')
END
GO
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name = 'RecordSet') BEGIN
	EXEC ('CREATE SCHEMA [RecordSet]')
END
GO
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name = 'Common') BEGIN
	EXEC ('CREATE SCHEMA [Common]')
END
GO
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name = 'BlastN') BEGIN
	EXEC ('CREATE SCHEMA [BlastN]')
END
GO
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name = 'Job') BEGIN
	EXEC ('CREATE SCHEMA [Job]')
END
GO
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name = 'NCBI') BEGIN
	EXEC ('CREATE SCHEMA [NCBI]')
END
GO
IF NOT EXISTS (SELECT * FROM sys.schemas s WHERE s.name = 'Taxonomy') BEGIN
	EXEC ('CREATE SCHEMA [Taxonomy]')
END
GO